Set up transaction analysis codes
Find this screen
Open: Settings > Organisational and Financial > Transaction Analysis Codes
How to
Change the label for the transaction analysis code field
Open: Settings > Organisational and Financial > System Settings.
- Click Edit.
- In the Name of transaction analysis heading, enter a new label.
- Click OK.
Add and amend analysis codes
- Select a blank line or click Add.
- Enter a Code and Description.
- Select Active to use the code. If you change the code
If you change the code, you won't be able to report on transactions that used the previous code.
Delete analysis codes
You can delete a code, but once deleted, you won't be able to report on transactions that used this code.
If you don't want to apply a code to any future transactions, but still want to report on it, clear the Active check box. The code is not displayed when transactions are entered but can still be selected for reporting.
Useful info
What is transaction analysis?
Transaction analysis is a way of sorting and grouping posted transactions in Sage 200.
Each transaction has a Transaction Analysis column where you can enter a code to identify the transaction.
As Transaction Analysis is not a term relevant to most businesses, you can enter a your own label (Heading) for this field
You can add a transaction analysis code to the following transactions: sales invoice, sales credit note, purchase invoice, purchase credit note, nominal journal, nominal payment and nominal receipt.
- Enter the Name of transaction analysis heading you want for this column
- Create your transaction analysis codes. You choose which code to apply to each transaction from a drop-down list.
- When you enter a transaction, select the required code.
- You can then report on transactions grouped by transaction analysis code.
You have decided to use transaction analysis codes to help measure the success of your marketing campaigns.
You enter Marketing campaign as the heading for the transaction analysis column.
You create codes to reflect your marketing campaigns such as TV advert, Radio advert, Press, Website and so on.
Each time a sales invoice is recorded, the relevant code is selected. At the end of a period you can see the total of the invoices recorded for each code.
How to use transaction analysis
You can add transaction analysis codes to the following transactions in these modules.
| Area | Where analysis codes are applied |
|---|---|
| Nominal Ledger |
Journal Entry Nominal Vatable Receipt Nominal Vatable Payment Nominal Non-Vatable Receipt Nominal Non-Vatable Payment Prepayments Accruals Previous Year Journal Entry Journal templates |
| Customers |
Sales Invoice Sales Credit Note Batched Sales Transactions - Invoice Batched Sales Transactions - Credit Note |
| Suppliers |
Purchase Invoice Rapid invoice Purchase Credit Note Batched Purchase Transactions - Invoice Batched Purchase Transactions - Credit note |
| Cash Book |
Standing orders / Direct debits |
Reporting on transaction analysis codes
After taking the time to set up and apply transaction analysis codes you are going to want to see some benefit from them. Below is a list of the reports and enquiries which group transactions linked by transaction analysis codes.
- Enquiries
- Transaction enquiry
- Reports
- Transaction Listing
- URN report
- Previous Year Journal List
- Manual Journal List
- Workspaces
- Nominal Current Transaction Enquiry
- Nominal Deferred Postings (can be added as a column)
What happens when I
Save a new code?
The new code is added the drop-down list so you can select it on new transactions.
Change a code
The new code can be selected on new transactions. If you change the code, you won't be able to report on transactions that used the previous code.
Make a code Inactive
You won't be able to select the code on any future transactions.